home *** CD-ROM | disk | FTP | other *** search
/ Die Ultimative Software-P…i Collection 1996 & 1997 / Die Ultimative Software-Pakete CD-ROM fur Atari Collection 1996 & 1997.iso / d / dateiver / cia1_10 / spreadsh.eet / planung.asc < prev    next >
Encoding:
Text File  |  1996-09-18  |  12.8 KB  |  241 lines
  1. Pos. Aufwands/Ertrags-Art      1. Jahr             2. Jahr  
  2. Nr.                             Betrag      %       Betrag  
  3. ____________________________________________________________
  4. 1    Umsatzerlös               1.600,00+   100,00+ 2.000,00+
  5. 2    Skontoertrag                  0,00+     0,00+     0,00+
  6. 3    Bestandsveränderungen         0,00+     0,00+     0,00+
  7. ____________________________________________________________
  8. 4    Gesamtleistung (1-3)      1.600,00+   100,00+ 2.000,00+
  9. ____________________________________________________________
  10. 5    Wareneinsatz                384,00+    24,00+   480,00+
  11. ____________________________________________________________
  12. 6    Brutto-/Rohertrag         1.216,00+    76,00+ 1.520,00+
  13. ____________________________________________________________
  14. 7    Skontoaufwand                16,00+     1,00+    20,00+
  15. 8    Vertreterprovisionen        363,20+    22,70+   454,00+
  16. 9    Verpackung u. Versand        32,00+     2,00+    40,00+
  17. 10                                 0,00+     0,00+     0,00+
  18. ____________________________________________________________
  19. 11   Summe Variabler Kosten      411,20+    25,70+   514,00+
  20. ____________________________________________________________
  21. 12   Deckungsbeitrag 1           804,80+    50,30+ 1.006,00+
  22. ____________________________________________________________
  23. 13   Finanzierungkosten           22,80+     1,42+    12,00+
  24. ____________________________________________________________
  25. 14   Deckungsbeitrag 2           782,00+    48,88+   994,00+
  26. ____________________________________________________________
  27. 15   Mieten                       30,00+     1,88+    30,00+
  28. 16   Personalkosten              211,20+    13,20+   211,20+
  29. 17   Betriebssteuern               0,00+     0,00+     0,00+
  30. 18   Versicherungen                2,40+     0,15+     2,40+
  31. 19   Beiträge u. Gebühren          4,80+     0,30+     4,80+
  32. 20   KFZ-Aufwand                  33,60+     2,10+    33,60+
  33. 21   Leasingaufwand               22,80+     1,42+    22,80+
  34. 22   Fahrt- u. Reiseaufwand       18,00+     1,13+    18,00+
  35. 23   Eingangsfrachten              0,00+     0,00+     0,00+
  36. 24   Reparaturen, Ersatzteile      0,00+     0,00+     0,00+
  37. 25   Bewirtung                     3,00+     0,19+     3,00+
  38. 26   Energie (Gas,Strom,Wasser     6,00+     0,38+     6,00+
  39. 27   Allg. Bürokosten (Porti,                               
  40.      Tel.,Tx.,Zeitschr. etc.)     32,40+     2,03+    32,40+
  41. 28   Rechts-u. Beratungsaufw.      9,60+     0,60+     9,60+
  42. 29   Rechnungswesen               12,00+     0,75+    12,00+
  43. 30   Geldverkehrsaufwand          12,00+     0,75+    12,00+
  44. 31   Schadensfälle (Kund.ford.     9,00+     0,56+     9,00+
  45. 32   AfA                          23,40+     1,46+    23,40+
  46. ____________________________________________________________
  47. 33   Fixe Kosten Gesamt          430,20+    26,89+   430,20+
  48. ____________________________________________________________
  49. 34   A.O. Aufwand                205,00+    12,81+   200,00+
  50. ____________________________________________________________
  51. 35   Erfolg (Gewinn/Verlust)                                
  52.      vor Ertragssteuern          146,80+     9,18+   363,80+
  53. ============================================================
  54.                                                             
  55.      12.01.1989/CALC                                        
  56.      Dr.L.Marte                                             
  57.                                                             
  58.                                                             
  59.                                                             
  60.                                                             
  61.            3. Jahr              Gesamt                      
  62.     %       Betrag      %       Betrag      %               
  63. __________________________________________________          
  64.    100,00+ 2.400,00+   100,00+ 6.000,00+   100,00+          
  65.      0,00+     0,00+     0,00+     0,00+     0,00+          
  66.      0,00+     0,00+     0,00+     0,00+     0,00+          
  67. __________________________________________________          
  68.    100,00+ 2.400,00+   100,00+ 6.000,00+   100,00+          
  69. __________________________________________________          
  70.     24,00+   576,00+    24,00+ 1.440,00+    24,00+          
  71. __________________________________________________          
  72.     76,00+ 1.824,00+    76,00+ 4.560,00+    76,00+          
  73. __________________________________________________          
  74.      1,00+    24,00+     1,00+    60,00+     1,00+          
  75.     22,70+   544,80+    22,70+ 1.362,00+    22,70+          
  76.      2,00+    48,00+     2,00+   120,00+     2,00+          
  77.      0,00+     0,00+     0,00+     0,00+     0,00+          
  78. __________________________________________________          
  79.     25,70+   616,80+    25,70+ 1.542,00+    25,70+          
  80. __________________________________________________          
  81.     50,30+ 1.207,20+    50,30+ 3.018,00+    50,30+          
  82. __________________________________________________          
  83.      0,60+     0,00+     0,00+    34,80+     0,58+          
  84. __________________________________________________          
  85.     49,70+ 1.207,20+    50,30+ 2.983,20+    49,72+          
  86. __________________________________________________          
  87.      1,50+    30,00+     1,25+    90,00+     1,50+          
  88.     10,56+   211,20+     8,80+   633,60+    10,56+          
  89.      0,00+     0,00+     0,00+     0,00+     0,00+          
  90.      0,12+     2,40+     0,10+     7,20+     0,12+          
  91.      0,24+     4,80+     0,20+    14,40+     0,24+          
  92.      1,68+    33,60+     1,40+   100,80+     1,68+          
  93.      1,14+    22,80+     0,95+    68,40+     1,14+          
  94.      0,90+    18,00+     0,75+    54,00+     0,90+          
  95.      0,00+     0,00+     0,00+     0,00+     0,00+          
  96.      0,00+     0,00+     0,00+     0,00+     0,00+          
  97.      0,15+     3,00+     0,13+     9,00+     0,15+          
  98.      0,30+     6,00+     0,25+    18,00+     0,30+          
  99.                                                             
  100.      1,62+    32,40+     1,35+    97,20+     1,62+          
  101.      0,48+     9,60+     0,40+    28,80+     0,48+          
  102.      0,60+    12,00+     0,50+    36,00+     0,60+          
  103.      0,60+    12,00+     0,50+    36,00+     0,60+          
  104.      0,45+     9,00+     0,38+    27,00+     0,45+          
  105.      1,17+    23,40+     0,97+    70,20+     1,17+          
  106. __________________________________________________          
  107.     21,51+   430,20+    17,92+ 1.290,60+    21,51+          
  108. __________________________________________________          
  109.     10,00+   200,00+     8,33+   605,00+    10,08+          
  110. __________________________________________________          
  111.                                                             
  112.     18,19+   577,00+    24,04+ 1.087,60+    18,13+          
  113. ==================================================          
  114.                                                             
  115.                                                             
  116.                                                             
  117.                                                             
  118.                                                             
  119.                                                             
  120.                                                             
  121.                                                             
  122.                                                             
  123.                                                             
  124.                                                             
  125.                                                             
  126.                                                             
  127.                                                             
  128.                                                             
  129.                                                             
  130.                                                             
  131.                                                             
  132.                                                             
  133.                                                             
  134.                                                             
  135.                                                             
  136.                                                             
  137.                                                             
  138.                                                             
  139.                                                             
  140.                                                             
  141.                                                             
  142.                                                             
  143.                                                             
  144.                                                             
  145.                                                             
  146.                                                             
  147.                                                             
  148.                                                             
  149.                                                             
  150.                                                             
  151.                                                             
  152.                                                             
  153.                                                             
  154.                                                             
  155.                                                             
  156.                                                             
  157.                                                             
  158.                                                             
  159.                                                             
  160.                                                             
  161.                                                             
  162.                                                             
  163.                                                             
  164.                                                             
  165.                                                             
  166.                                                             
  167.                                                             
  168.                                                             
  169.                                                             
  170.                                                             
  171.                                                             
  172.                                                             
  173.                                                             
  174.                                                             
  175.                                                             
  176.                                                             
  177.                                                             
  178.                                                             
  179.                                                             
  180.                                                             
  181.                               
  182.                               
  183.                               
  184.                               
  185.                               
  186.                               
  187.                               
  188.                               
  189.                               
  190.                               
  191.                               
  192.                               
  193.                               
  194.                               
  195.                               
  196.                               
  197.                               
  198.                               
  199.                               
  200.                               
  201.                               
  202.                               
  203.                               
  204.                               
  205.                               
  206.                               
  207.                               
  208.                               
  209.                               
  210.                               
  211.                               
  212.                               
  213.                               
  214.                               
  215.                               
  216.                               
  217.                               
  218.                               
  219.                               
  220.                               
  221.                               
  222.                               
  223.                               
  224.                               
  225.                               
  226.                               
  227.                               
  228.                               
  229.                               
  230.                               
  231.                               
  232.                               
  233.                               
  234.                               
  235.                               
  236.                               
  237.                               
  238.                               
  239.                               
  240.                               
  241.